Title: SQL W3S (By-BKK) / 102 Drop DB
Tags: Obsidian_to_Anki

Q: What does the SQL DROP DATABASE statement do?
A: It deletes an existing SQL database

Q: True or False: Using DROP DATABASE will delete all the information in the database permanently
A: True

Q: What is the syntax for dropping a database in SQL?
A: DROP DATABASE databasename;

Q: Why should you be careful before using DROP DATABASE?
A: Because it will result in loss of all information stored in the database

Q: Who needs admin privilege to drop a database in SQL?
A: Only users with admin privilege

Q: How can you verify if a database has been dropped?
A: Use the SQL command SHOW DATABASES;

Q: DROP DATABASE testDB;
A: This SQL command deletes the database named testDB

Q: True or False: DROP DATABASE can be used to delete only specific tables from a database
A: False

Q: To delete a database, which SQL keyword is used?
A: DROP DATABASE

Q: Which statement will result in deletion of the database named "shopDB"?
A: DROP DATABASE shopDB;

Q: Reverse card:
Which SQL command can you use to check the list of databases after dropping one?
A: SHOW DATABASES;